Dataset contains 8,760 rows and 36 columns (after dropping attributes)
Key column categories:
- Station info: STATION, DATE, LATITUDE, LONGITUDE, ELEVATION, NAME
- Weather variables: Cloud, DewPoint, Pressure, Temperature, Wind
| Pittsburgh Hourly Weather Observations (1981–2010) | |||||
| Cloud (% Clear) | DewPoint (°F) | Pressure (hPa) | Temperature (°F) | Wind (MPH) | |
|---|---|---|---|---|---|
| count | 8760.0 | 8760.0 | 8760.0 | 8760.0 | 8760.0 |
| mean | 13.12 | 40.57 | 1017.74 | 51.57 | 8.09 |
| std | 8.77 | 14.91 | 1.66 | 16.39 | 2.29 |
| min | 0.7 | 17.6 | 1014.1 | 23.8 | 3.4 |
| 25% | 6.3 | 25.9 | 1016.3 | 36.1 | 6.3 |
| 50% | 10.8 | 39.0 | 1018.0 | 51.75 | 8.3 |
| 75% | 18.3 | 56.4 | 1019.1 | 65.5 | 9.7 |
| max | 41.4 | 63.4 | 1021.5 | 81.2 | 13.3 |
| Cloud (Scattered %) | Temperature (°F) | Wind (MPH) | |
|---|---|---|---|
| Month | |||
| 1 | 5.93 | 28.71 | 9.63 |
| 2 | 6.46 | 31.48 | 9.41 |
| 3 | 7.38 | 39.69 | 9.56 |
| 4 | 8.54 | 51.33 | 9.28 |
| 5 | 11.00 | 60.52 | 7.92 |
| 6 | 15.00 | 69.10 | 7.05 |
| 7 | 16.65 | 72.83 | 6.50 |
| 8 | 15.33 | 71.31 | 6.16 |
| 9 | 11.95 | 64.14 | 6.58 |
| 10 | 9.84 | 52.78 | 7.36 |
| 11 | 7.89 | 42.89 | 8.58 |
| 12 | 5.94 | 32.80 | 9.15 |
Findings:
- June-August: temperature rises and wind decreases causing more scattered clouds in the sky.
- September-December: temperature falls and wind picks up, while cloud cover decreases.
- This proves the higher the temperature and slower the wind, the more clouds there are and vice versa.
This chart displays the daily average temperature (blue line) and dew point (red line) from 1981 to 2010. The shaded regions show the typical range (\(\text{10}^{\text{th}}\) to \(\text{90}^{\text{th}}\) percentile) for each measurement. The overlapping area between the blue (temperature) and red (dew point) ranges indicates the days and temperatures where the air is expected to be fully saturated with moisture (100% relative humidity)
This graph shows negative relation ship between dew point and wind speed broken down by time of day.
| Season | Spring | Summer | Fall | Winter |
|---|---|---|---|---|
| Pressure_Range_hPa | ||||
| 1014-1015 | 240 | 120 | 0 | 0 |
| 1015-1016 | 811 | 533 | 0 | 0 |
| 1016-1017 | 617 | 750 | 0 | 18 |
| 1017-1018 | 384 | 572 | 141 | 113 |
| 1018-1019 | 156 | 206 | 868 | 665 |
| 1019-1020 | 0 | 27 | 939 | 997 |
| 1020+ | 0 | 0 | 236 | 367 |